/*
 Navicat Premium Data Transfer

 Source Server         : 本地
 Source Server Type    : MySQL
 Source Server Version : 80021 (8.0.21)
 Source Host           : localhost:3306
 Source Schema         : back_manage

 Target Server Type    : MySQL
 Target Server Version : 80021 (8.0.21)
 File Encoding         : 65001

 Date: 11/04/2024 17:27:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dictionary
-- ----------------------------
DROP TABLE IF EXISTS `sys_dictionary`;
CREATE TABLE `sys_dictionary` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `parent_id` bigint NOT NULL DEFAULT '0' COMMENT '父id',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '含义',
  `dict_val` varchar(100) NOT NULL DEFAULT '' COMMENT '字典val',
  `dict_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '字典key',
  `weight` int NOT NULL DEFAULT '0' COMMENT '权重',
  `status` tinyint NOT NULL DEFAULT '1' COMMENT '状态（1 启用；0禁用）',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0：未删除，1：已删除',
  `create_user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '创建用户',
  `create_username` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '创建用户名',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_dict_key` (`dict_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='数据字典表';

-- ----------------------------
-- Records of sys_dictionary
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `url` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'url',
  `path` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT 'path',
  `component` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '组件',
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '菜单名',
  `icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '图标',
  `parent_id` bigint DEFAULT NULL COMMENT '父id',
  `weight` int NOT NULL DEFAULT '0' COMMENT '权重',
  `enabled` int DEFAULT '1' COMMENT '是否启用，1：启用 0：不启用',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0：未删除，1：已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `parentId` (`parent_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu` (`id`, `url`, `path`, `component`, `name`, `icon`, `parent_id`, `weight`, `enabled`, `create_time`, `update_time`, `deleted`) VALUES (1, '/', '', NULL, '所有', NULL, 0, 0, 1, '2024-04-03 11:07:53', '2024-04-03 11:12:29', 0);
INSERT INTO `sys_menu` (`id`, `url`, `path`, `component`, `name`, `icon`, `parent_id`, `weight`, `enabled`, `create_time`, `update_time`, `deleted`) VALUES (2, '', '', NULL, '系统工具', 'el-icon-s-tools', 1, 200, 1, '2024-04-03 11:14:28', '2024-04-03 11:15:47', 0);
INSERT INTO `sys_menu` (`id`, `url`, `path`, `component`, `name`, `icon`, `parent_id`, `weight`, `enabled`, `create_time`, `update_time`, `deleted`) VALUES (3, '', '', NULL, '系统管理', 'el-icon-s-home', 1, 1, 1, '2024-04-03 11:14:28', '2024-04-03 11:23:51', 0);
INSERT INTO `sys_menu` (`id`, `url`, `path`, `component`, `name`, `icon`, `parent_id`, `weight`, `enabled`, `create_time`, `update_time`, `deleted`) VALUES (4, '/sys/user/**', '/ManagerManagement', 'ManagerManagement', '管理员管理', 'el-icon-user', 3, 5, 1, '2024-04-03 11:18:38', '2024-04-03 11:23:51', 0);
INSERT INTO `sys_menu` (`id`, `url`, `path`, `component`, `name`, `icon`, `parent_id`, `weight`, `enabled`, `create_time`, `update_time`, `deleted`) VALUES (5, '/sys/menu/**', '/MenuManagement', 'MenuManagement', '菜单管理', 'el-icon-menu', 3, 10, 1, '2024-04-03 11:20:32', '2024-04-03 11:23:51', 0);
INSERT INTO `sys_menu` (`id`, `url`, `path`, `component`, `name`, `icon`, `parent_id`, `weight`, `enabled`, `create_time`, `update_time`, `deleted`) VALUES (6, '', '/CalendarManagement', 'CalendarManagement', '日历', 'el-icon-date', 2, 5, 1, '2024-04-03 11:25:59', '2024-04-03 11:26:03', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu_role`;
CREATE TABLE `sys_menu_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `menu_id` bigint NOT NULL COMMENT '菜单id',
  `role_id` bigint NOT NULL COMMENT '角色id',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0：未删除，1：已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_menu_id` (`menu_id`) USING BTREE,
  KEY `index_role_id` (`role_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单角色关系表';

-- ----------------------------
-- Records of sys_menu_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 1, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (2, 2, 1, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (3, 3, 1, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (4, 4, 1, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (5, 5, 1, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (6, 6, 1, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (7, 1, 2, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (8, 2, 2, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (9, 3, 2, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (10, 5, 2, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (11, 6, 2, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (12, 1, 3, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
INSERT INTO `sys_menu_role` (`id`, `menu_id`, `role_id`, `create_time`, `update_time`, `deleted`) VALUES (13, 6, 3, '2024-04-07 10:23:20', '2024-04-07 10:23:20', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_operate_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operate_log`;
CREATE TABLE `sys_operate_log` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `log_id` bigint NOT NULL COMMENT '日志唯一值',
  `query_id` varchar(100) NOT NULL COMMENT '查询值，例如：订单号',
  `module` varchar(100) NOT NULL DEFAULT '0' COMMENT '模块',
  `log_type` varchar(100) NOT NULL DEFAULT '0' COMMENT '操作类型',
  `context` text COMMENT '日志内容',
  `ext` json DEFAULT NULL COMMENT '附录',
  `user_phone` varchar(18) DEFAULT '' COMMENT '修改人手机号',
  `create_user` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '创建人',
  `create_user_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL DEFAULT '' COMMENT '创建人ID',
  `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `unq_log_id` (`log_id`),
  KEY `idx_query_id` (`query_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='操作日志表';

-- ----------------------------
-- Records of sys_operate_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限编码',
  `type` int DEFAULT NULL COMMENT '权限类型-取自数据字典表的ID',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限名',
  `value` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '权限配置内容',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0表示未删除，1表示已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='权限表';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (1, 'user-personal-get', NULL, '查询用户个人信息', '', '', '2024-04-10 17:26:55', '2024-04-10 17:26:55', 0);
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (2, 'user-get', NULL, '查询用户信息列表', '', '', '2024-04-10 17:27:20', '2024-04-10 17:27:20', 0);
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (3, 'user-add-update', NULL, '用户新增或修改', '', '', '2024-04-10 17:32:40', '2024-04-10 17:32:40', 0);
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (4, 'user-delete', NULL, '删除用户', '', '', '2024-04-10 17:32:40', '2024-04-10 17:32:40', 0);
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (5, 'user-grant-roles', NULL, '用户分配角色', '', '', '2024-04-10 17:33:35', '2024-04-10 17:33:35', 0);
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (7, 'user-*', NULL, '用户所有权限', '', '', '2024-04-10 17:37:01', '2024-04-10 17:37:01', 0);
INSERT INTO `sys_permission` (`id`, `code`, `type`, `name`, `value`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (8, 'user-modify-pwd', NULL, '用户修改密码', '', '', '2024-04-10 17:44:11', '2024-04-10 17:44:11', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色编码',
  `role_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '角色名',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0：未删除，1：已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` (`id`, `code`, `role_name`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (1, 'super_admin', '超级管理员', '具备系统的所有权限', '2024-04-03 11:02:41', '2024-04-03 11:02:41', 0);
INSERT INTO `sys_role` (`id`, `code`, `role_name`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (2, 'admin', '管理员', '', '2024-04-03 11:02:41', '2024-04-03 11:02:41', 0);
INSERT INTO `sys_role` (`id`, `code`, `role_name`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (3, 'general_user', '普通用户', '', '2024-04-03 11:02:41', '2024-04-03 11:02:41', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `permission_id` bigint NOT NULL COMMENT '权限ID',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0：未删除，1：已删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色权限关系表';

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_permission` (`id`, `role_id`, `permission_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (2, 2, 1, '', '2024-04-10 17:28:23', '2024-04-10 17:28:23', 0);
INSERT INTO `sys_role_permission` (`id`, `role_id`, `permission_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (3, 3, 1, '', '2024-04-10 17:28:23', '2024-04-10 17:28:23', 0);
INSERT INTO `sys_role_permission` (`id`, `role_id`, `permission_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (5, 2, 2, '', '2024-04-10 17:28:59', '2024-04-10 17:28:59', 0);
INSERT INTO `sys_role_permission` (`id`, `role_id`, `permission_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (6, 1, 7, '', '2024-04-10 17:37:56', '2024-04-10 17:37:56', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_user`;
CREATE TABLE `sys_role_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `role_id` bigint NOT NULL COMMENT '角色ID',
  `user_id` bigint NOT NULL COMMENT '用户ID',
  `remark` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '备注',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除标识，0：未删除，1：已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_user_id` (`user_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色关系表';

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_user` (`id`, `role_id`, `user_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (1, 1, 1, '', '2024-04-03 11:03:32', '2024-04-03 11:03:32', 0);
INSERT INTO `sys_role_user` (`id`, `role_id`, `user_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (2, 2, 1, '', '2024-04-03 11:03:32', '2024-04-03 11:03:32', 0);
INSERT INTO `sys_role_user` (`id`, `role_id`, `user_id`, `remark`, `create_time`, `update_time`, `deleted`) VALUES (3, 3, 1, '', '2024-04-03 11:03:32', '2024-04-03 11:03:32', 0);
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名',
  `login_account` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '登录账号',
  `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码',
  `profile_photo` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '头像',
  `sex` int DEFAULT NULL COMMENT '性别（男 1，女 0）',
  `age` int DEFAULT NULL COMMENT '年龄',
  `birthday` timestamp NULL DEFAULT NULL COMMENT '出生日期',
  `phone` varchar(32) DEFAULT NULL COMMENT '电话',
  `create_user_id` bigint NOT NULL DEFAULT '1' COMMENT '创建人id',
  `create_username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT 'system' COMMENT '创建人用户名',
  `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  `deleted` int NOT NULL DEFAULT '0' COMMENT '逻辑删除，0表示未删除，1表示已删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `index_deleted` (`deleted`) USING BTREE,
  KEY `index_username` (`username`) USING BTREE,
  KEY `index_login_account` (`login_account`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` (`id`, `username`, `login_account`, `password`, `profile_photo`, `sex`, `age`, `birthday`, `phone`, `create_user_id`, `create_username`, `create_time`, `update_time`, `deleted`) VALUES (1, '管理员', 'admin', '8fOqsZ9KPOqYLwgO8mj3Ng==', NULL, NULL, NULL, NULL, NULL, 1, 'system', '2024-03-21 13:03:56', '2024-03-21 13:03:56', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
